package com.shebao.utils.excel;

import org.jeecgframework.poi.excel.annotation.Excel;
import org.jeecgframework.poi.excel.annotation.ExcelTarget;

@ExcelTarget("personEntity")
public class PersonEntity {
	@Excel(name = "姓名", orderNum = "1")
	private String userName;
	@Excel(name = "社保编码", orderNum = "1")
	private String socialId;
	@Excel(name = "身份证号", orderNum = "1")
	private String cardId;
	@Excel(name = "验证码", orderNum = "1")
	private String code;
	@Excel(name = "缴费月份", orderNum = "1")
	private String payDate;
	@Excel(name = "单位编码", orderNum = "1")
	private String companyId;
	
	@Excel(name = "养老基数", orderNum = "1")
	private String oldBase;
	@Excel(name = "养老单位", orderNum = "1")
	private String oldCompany;
	@Excel(name = "养老个人", orderNum = "1")
	private String oldPerson;
	
	@Excel(name = "医疗基数", orderNum = "1")
	private String medicalBase;
	@Excel(name = "医疗单位", orderNum = "1")
	private String medicalCompany;
	@Excel(name = "医疗个人", orderNum = "1")
	private String medicalPerson;
	
	@Excel(name = "补充基数", orderNum = "1")
	private String supplyBase;
	@Excel(name = "补充单位", orderNum = "1")
	private String supplyCompany;
	@Excel(name = "补充个人", orderNum = "1")
	private String supplyPerson;
	
	@Excel(name = "生育基数", orderNum = "1")
	private String birthBase;
	@Excel(name = "生育单位", orderNum = "1")
	private String birthCompany;
	@Excel(name = "生育个人", orderNum = "1")
	private String birthPerson;

	@Excel(name = "失业基数", orderNum = "1")
	private String unemploymentBase;
	@Excel(name = "失业单位", orderNum = "1")
	private String unemploymentCompany;
	@Excel(name = "失业个人", orderNum = "1")
	private String unemploymentPerson;
	
	@Excel(name = "工伤基数", orderNum = "1")
	private String hurtBase;
	@Excel(name = "工伤单位", orderNum = "1")
	private String hurtCompany;
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getSocialId() {
		return socialId;
	}
	public void setSocialId(String socialId) {
		this.socialId = socialId;
	}
	public String getCardId() {
		return cardId;
	}
	public void setCardId(String cardId) {
		this.cardId = cardId;
	}
	public String getCode() {
		return code;
	}
	public void setCode(String code) {
		this.code = code;
	}
	public String getPayDate() {
		return payDate;
	}
	public void setPayDate(String payDate) {
		this.payDate = payDate;
	}
	public String getCompanyId() {
		return companyId;
	}
	public void setCompanyId(String companyId) {
		this.companyId = companyId;
	}
	public String getOldBase() {
		oldBase=format(oldBase);
		return oldBase;
	}
	public void setOldBase(String oldBase) {
		this.oldBase = oldBase;
	}
	public String getOldCompany() {
		oldCompany=format(oldCompany);
		return oldCompany;
	}
	public void setOldCompany(String oldCompany) {
		this.oldCompany = oldCompany;
	}
	public String getOldPerson() {
		oldPerson=format(oldPerson);
		return oldPerson;
	}
	public void setOldPerson(String oldPerson) {
		this.oldPerson = oldPerson;
	}
	public String getMedicalBase() {
		medicalBase=format(medicalBase);
		return medicalBase;
	}
	public void setMedicalBase(String medicalBase) {
		this.medicalBase = medicalBase;
	}
	public String getMedicalCompany() {
		medicalCompany=format(medicalCompany);
		return medicalCompany;
	}
	public void setMedicalCompany(String medicalCompany) {
		this.medicalCompany = medicalCompany;
	}
	public String getMedicalPerson() {
		medicalPerson=format(medicalPerson);
		return medicalPerson;
	}
	public void setMedicalPerson(String medicalPerson) {
		this.medicalPerson = medicalPerson;
	}
	public String getSupplyBase() {
		supplyBase=format(supplyBase);
		return supplyBase;
	}
	public void setSupplyBase(String supplyBase) {
		this.supplyBase = supplyBase;
	}
	public String getSupplyCompany() {
		supplyCompany=format(supplyCompany);
		return supplyCompany;
	}
	public void setSupplyCompany(String supplyCompany) {
		this.supplyCompany = supplyCompany;
	}
	public String getSupplyPerson() {
		supplyPerson=format(supplyPerson);
		return supplyPerson;
	}
	public void setSupplyPerson(String supplyPerson) {
		this.supplyPerson = supplyPerson;
	}
	public String getBirthBase() {
		birthBase=format(birthBase);
		return birthBase;
	}
	public void setBirthBase(String birthBase) {
		this.birthBase = birthBase;
	}
	public String getBirthCompany() {
		birthCompany=format(birthCompany);
		return birthCompany;
	}
	public void setBirthCompany(String birthCompany) {
		this.birthCompany = birthCompany;
	}
	public String getBirthPerson() {
		birthPerson=format(birthPerson);
		return birthPerson;
	}
	public void setBirthPerson(String birthPerson) {
		this.birthPerson = birthPerson;
	}
	public String getUnemploymentBase() {
		unemploymentBase=format(unemploymentBase);
		return unemploymentBase;
	}
	public void setUnemploymentBase(String unemploymentBase) {
		this.unemploymentBase = unemploymentBase;
	}
	public String getUnemploymentCompany() {
		unemploymentCompany=format(unemploymentCompany);
		return unemploymentCompany;
	}
	public void setUnemploymentCompany(String unemploymentCompany) {
		this.unemploymentCompany = unemploymentCompany;
	}
	public String getUnemploymentPerson() {
		unemploymentPerson=format(unemploymentPerson);
		return unemploymentPerson;
	}
	public void setUnemploymentPerson(String unemploymentPerson) {
		this.unemploymentPerson = unemploymentPerson;
	}
	public String getHurtBase() {
		hurtBase=format(hurtBase);
		return hurtBase;
	}
	public void setHurtBase(String hurtBase) {
		this.hurtBase = hurtBase;
	}
	public String getHurtCompany() {
		hurtCompany=format(hurtCompany);
		return hurtCompany;
	}
	public void setHurtCompany(String hurtCompany) {
		this.hurtCompany = hurtCompany;
	}

	public String format(String s){
		if(s.contains(".")){
			String[] sa=s.split("\\.");
			String s2=sa[1];
			if(s2.length()==1){
				s=s+"0";
			}
		}
		return s;
	}
	public static void main(String[] args) {
		new PersonEntity().format("2017.0");
	}
}
